Integrate Actual Costs Process

Use the Integrate Actual Costs API process to import actual costs into a project in progress.

Process Settings

Below are the settings you must define for the Integrate Actual Costs API process.

Setting	Description	Sample Value
ProcessID	This setting informs Cobra to run the Integrate Actual Costs process.	IntegrateActualCosts
ConfigurationName	This setting refers to the name of the configuration stored in the database. The configuration file is created on the last page of the Integration Wizard and contains the list of actions to be run on the project. This setting is required.	MyConfig
Project	This setting refers to the project where you want to import actual costs. This setting is required.	Demo Advanced
TransactionFile	This setting refers to the file that contains the data you want to import. This must be a fully qualified filename. This setting optional. By default, this field is set to the settings in the configuration file.	C:\Cobra\System\Demodata\Trn\ac_tran1.csv
ConfigurationOwner	This setting is optional. However, if the user ID running the API process is not the owner of the configuration file, you must define this setting in the API script.	SYSADMIN
ExclusionFile	This setting forces the zeroing process to ignore the actual costs contained in a file. The exception file must be in the same format (Format 1 or Format 2) and have the same column order as the actuals import file. This setting is ignored if the ZeroUnreferencedActualCosts field is not set to 1. This setting is optional.	C:\Cobra\IgnoreTheseRecords.csv
ValidateOnly	Use this setting to validate the actual costs without posting any data to the Cobra database. This setting is optional and the default value is 0.	1
Class	If the file does not include the actuals class, this setting is used to determine the class that will hold the data when loaded. The value must be an actuals class in the Cobra project; otherwise the process will not be completed successfully. This setting is optional.	Actual
ClassId	This setting is optional and can be used instead of the Class setting.	Actual
FieldList	This setting holds a comma-delimited list of the fields used when loading data from an import file. The field list is used to determine the position of the data being loaded into Cobra. The field list must use field labels such as CA1, CA2, WP, CECODE, HOURS, DIRECT, OVERHEAD, or GANDA and not WBS or Resource. The fields are separated by commas and there should not be any spaces between the fields. This setting is optional.	CA1,CECODE,HOURS,DIRECT
IgnoreClassList	This setting forces the zeroing process to skip any actual cost records whose class appears in the defined cost class list. This setting is ignored if ZeroUnreferencedActualCosts is not set to 1. This setting is optional.	Budget,Forecast,OTB
ResultsToCalculate	This setting holds a comma-delimited list of resource Results that are calculated after the actual costs are loaded. This setting is optional.	OVERHEAD,GANDA
ResultIdList	This setting is optional and can be used instead of the ResultsToCalculate setting.	OVERHEAD,GANDA
ZeroUnreferencedActualCosts	If value is set to 1, Cobra zeroes out actual cost records that do not have a corresponding entry in the load actuals import file. This setting is optional and the default value is 0.	1
FieldMapperColumnHeaders	This setting is optional and can be used instead of the FieldList setting.	CA1,CECODE,HOURS,DIRECT
ExcludedClassesIdList	This setting is optional and can be used instead of the IgnoreClassList setting.	Budget,Forecast,OTB

Sample Script

Below is a sample script file for the Integrate Actual Costs API process.

[Process004]
ProcessID=IntegrateActualCosts
Project=Demo Advanced
ConfigurationName=MyConfig
TransactionFile=F:\Accounting\Jan-10.csv
ConfigurationOwner=SYSADMIN
Class=Actual
FieldList=CA1,CECODE,HOURS,DIRECT
IgnoreClassList=Budget,Forecast,OTB
ResultsToCalculate=OVERHEAD,GANDA
ZeroUnreferencedActualCosts=1